Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# TO_NCHAR (character)

Syntax

to_nchar_char::=

Description of the illustration to_nchar_char.gif

Purpose

`TO_NCHAR` (character) converts a character string, `CHAR`, `VARCHAR2`, `CLOB`, or `NCLOB` value to the national character set. The value returned is always `NVARCHAR2`. This function is equivalent to the `TRANSLATE` ... `USING` function with a `USING` clause in the national character set.

See Also: "Data Conversion" and TRANSLATE ... USING

Examples

The following example converts `VARCHAR2` data from the `oe.customers` table to the national character set:

    SELECT TO_NCHAR(cust_last_name) FROM customers
       WHERE customer_id=103;

    TO_NCHAR(CUST_LAST_NAME)
    --------------------------------------------------
    Taylor